#!/bin/bash

TABLES=("area" "claim_info" "cv_src" "dd_table" "mort_10_13" "policy_acuary" "policy_client" "policy_surrender" "pre_add_exp_ratio" "prem_cv_real" "prem_std_real" "rsv_src")
for i in "${TABLES[@]}"
do
/export/server/sqoop/bin/sqoop import \
--connect jdbc:mysql://node1:3306/insurance \
--username root \
--password 123456 \
--table $i \
--hive-import \
--hive-overwrite \
--hive-database  insurance_ods \
--hive-table $i \
--fields-terminated-by '\t' \
-m 1
done